package com.ship.dispatch.model.execl;

import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.ContentRowHeight;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;

import java.io.Serializable;
import java.util.Date;

@Data
@ColumnWidth(25)
@HeadRowHeight(20)
@ContentRowHeight(18)
public class ShipRentExcel implements Serializable {
    private static final long serialVersionUID = 1L;

    @ColumnWidth(15)
    @ExcelProperty(value = "WEEK",index = 0)
    private Integer week;

    @ColumnWidth(15)
    @ExcelProperty(value = "DATE",index = 1)
    @JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
    private Date date;

    @ColumnWidth(15)
    @ExcelProperty(value = {"SPOT","West","138-150k ST"}, index = 2)
    private String westSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"SPOT","West","155-165k TFDE"}, index = 3)
    private String westTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"SPOT","West","174k 2-Stroke/MEGI/XDF"}, index = 4)
    private String westXDF;

    @ColumnWidth(15)
    @ExcelProperty(value = {"SPOT","East","138-150k ST"}, index = 5)
    private String eastSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"SPOT","East","155-165k TFDE"}, index = 6)
    private String eastTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"SPOT","East","174k 2-Stroke/MEGI/XDF"}, index = 7)
    private String eastXDF;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","6 Months","138-150k ST"}, index = 8)
    private String rentSixMonthSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","6 Months","155-165k TFDE"}, index = 9)
    private String rentSixMonthTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","6 Months","174k 2-Stroke/MEGI/XDF"}, index = 10)
    private String rentSixMonthXDF;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","12 Months","138-150k ST"}, index = 11)
    private String rentTwelveMonthSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","12 Months","155-165k TFDE"}, index = 12)
    private String rentTwelveMonthTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","12 Months","174k 2-Stroke/MEGI/XDF"}, index = 13)
    private String rentTwelveMonthXDF;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","36 Months","138-150k ST"}, index = 14)
    private String rentThirtySixMonthSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","36 Months","155-165k TFDE"}, index = 15)
    private String rentThirtySixMonthTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","36 Months","174k 2-Stroke/MEGI/XDF"}, index = 16)
    private String rentThirtySixMonthXDF;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","5 Years","138-150k ST"}, index = 17)
    private String rentSixtyMonthSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","5 Years","155-165k TFDE"}, index = 18)
    private String rentSixtyMonthTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","5 Years","174k 2-Stroke/MEGI/XDF"}, index = 19)
    private String rentSixtyMonthXDF;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","10 Years","138-150k ST"}, index = 20)
    private String rentHundredTwentyMonthSt;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","10 Years","155-165k TFDE"}, index = 21)
    private String rentHundredTwentyMonthTFDE;

    @ColumnWidth(15)
    @ExcelProperty(value = {"TERM","10 Years","174k 2-Stroke/MEGI/XDF"}, index = 22)
    private String rentHundredTwentyMonthXDF;
}
